2014-09-03 - 14158 - Enhancement - Incorrect Condition records open orders #SalesDistribution
Enhancement
14158 - Incorrect Condition records open orders
Purpose
Condition records in BW Open orders and contracts are not adding up correctly.
Admin Info
Purpose
|
Need to correct the Incorrect Condition record orders
|
Requested By
|
Sheila Halloran
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
09/03/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZSD_O05, ZSDC_OPN, ZSD_CONTR, ZSD_C15
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Analysis & design
|
08
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
20
|
4
|
Unit test in Dev
|
08
|
5
|
Quality Testing
|
08
|
6
|
Transports & test data
|
08
|
|
TOTAL
|
60
|
References
Prior Tickets
None
Documents
Open Margin Issue.xls
Functional Requirement
Purpose/WHY:
Email From Abe:
Please see attached file for Open Orders for account 1013729. This account has one open order, order 1985820. This order has 2 lines, for the same material. One line is shipping in September, the other in November. The open revenue on each line is correct; however, the open cost on each line is the total cost for the material across both lines. Likewise for commission and royalty. The attached file has the data right from BI, along with how it should actually read.
In Scope:
Condition infocube & DSO, Open Order infocube and Contract infocube.
Out of Scope:
None
Solution Summary
As the Sales order item is not included as key field in the Open(ZSDC_OPN), Contract(ZSD_CONTR), Condition DSO(ZSD_O05), Condition cube(ZSD_C15). The commision values are getting added up, due to this the values goes wrong when compared with the ECC.
1. Need to add the Sales Document Item Infoobject in Open Order Infocube, Condition Data DSO, Condition Infocube and Contract Infocube
2. Need to add the end routine logic to consider Sales Order item in Condition cube.
3. Need to check the dependencies & collect all the corresponding objects into the Transport Request.
4. Need to unit test & transport it to BPQ for further testing.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Need to check if the Commission & Royalty are populating correctly.
|
Commission & Royalty Should be populated correctly.
|
2
|
Need to check if the Open Cost is populating correctly.
|
Open Cost should be populated correctly.
|
3
|
Check if all the objects are collected into the transport request.
|
All the objects should be collected into the transport request.
|
Solution Details
1. Need to add the Sales Document Item (0S_ORD_ITEM) Infoobject in Open Order Cube(ZSDC_OPN), Condition Data DSO(ZSD_O05), Condition Infocube(ZSD_C15) and Contract Infocube (ZSD_CONTR).
2. Need to add the end routine logic to consider item in the transformations of Condition cube(ZSD_C15).
3. Need to check the dependencies & collect all the corresponding objects into the Transport Request.
4. Need to unit test & transport it to BPQ for further testing.
Issues
Analysed impact of including the sales order item in contract source and need to confirm there are no side effects of this design after unit testing.